IOSCursor.java

package de.fau.cs.mad.fly.ios.sqlite;

import com.badlogic.gdx.Gdx;
import com.badlogic.gdx.sql.DatabaseCursor;
import com.badlogic.gdx.sql.DatabaseFactory;
import com.badlogic.gdx.sql.SQLiteGdxRuntimeException;

import java.sql.Blob;
import java.sql.ResultSet;
import java.sql.SQLException;

import SQLite.Database;
import SQLite.JDBC2z.JDBCResultSet;

public class IOSCursor implements DatabaseCursor {
   
    private ResultSet resultSet = null;

    @Override
    public byte[] getBlob(int columnIndex) {
        try {
            Blob blob = resultSet.getBlob(columnIndex + 1);
            return blob.getBytes(1, (int) blob.length());
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the blob", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public double getDouble(int columnIndex) {
        try {
            return resultSet.getDouble(columnIndex + 1);
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the double", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public float getFloat(int columnIndex) {
        try {
            return resultSet.getFloat(columnIndex + 1);
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the float", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public int getInt(int columnIndex) {
        try {
            return resultSet.getInt(columnIndex + 1);
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the int", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public long getLong(int columnIndex) {
        try {
            return resultSet.getLong(columnIndex + 1);
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the long", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public short getShort(int columnIndex) {
        try {
            return resultSet.getShort(columnIndex + 1);
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the short", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public String getString(int columnIndex) {
        try {
            return resultSet.getString(columnIndex + 1);
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in getting the string", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public boolean next() {
        try {
            return resultSet.next();
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG,
                    "There was an error in moving the cursor to next", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    @Override
    public int getCount() {
        return getRowCount(resultSet);
    }

    @Override
    public void close() {
        try {
            resultSet.close();
        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG, "There was an error in closing the cursor", e);
            throw new SQLiteGdxRuntimeException(e);
        }
    }

    private int getRowCount(ResultSet resultSet) {

        if (resultSet == null) {
            return 0;
        }

        try {

            resultSet.last();

            return resultSet.getRow();

        } catch (SQLException e) {
            Gdx.app.log(DatabaseFactory.ERROR_TAG,
                    "There was an error counting the number of results", e);
            throw new SQLiteGdxRuntimeException(e);
        } finally {

            try {

                resultSet.beforeFirst();

            } catch (SQLException e) {
                Gdx.app.log(DatabaseFactory.ERROR_TAG,
                        "There was an error counting the number of results", e);
            }
        }
    }

    public void setNativeCursor(ResultSet resultSetRef) {
        resultSet = resultSetRef;
    }

}